package com.report.dto.response;

import cn.zhxu.bs.bean.DbField;
import cn.zhxu.bs.bean.SearchBean;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;

/**
 * @author summer
 * @version 1.0
 * @date 2024/8/8 14:50
 */
@Data
@SearchBean(tables = " member_upload m LEFT JOIN research_member r On m.member_id=r.id",autoMapTo = "m",orderBy = "m.create_time DESC")
public class MemberUploadRes implements Serializable {

    @DbField("m.id")
   private Integer id;

   @DbField("m.path")
   private String path;

   @DbField("r.idNum")
   private String idNum;

   @DbField("m.member_id")
   private Integer memberId;

   @DbField("r.phone")
   private String phone;

   @DbField("r.nickName")
   private String nickName;

   @DbField("m.file_name")
   private String fileName;

    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    @DbField("m.create_time")
    private LocalDateTime createTime;

    @DbField("m.status")
    private Integer status;

    @DbField("CASE WHEN m.status=0 THEN '未审核' ELSE '已审核' END")
    private String statusName;

}
